import pymysql

stri="1,2,3,4,5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,38,39,40,41,43,44,45,46,49,50,51,52,53,54,55,56,58,59,60,61,63,64,65,67,69,70,71,72"
c='61'

lis=stri.split(",")
print(lis)
sqld=[]
for i in range(1,98):
    if(str(i) not in lis):
        sqld.append((c,str(i)))

print(sqld)
    
db=pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='demhghc', db='zthubo', charset='utf8')
cur=db.cursor()
for v in sqld:
    cur.execute("select * from class_seatnum where bj = %s and seat=%s and status>0" , v)
    print(cur.fetchall())
cur.close()
db.close()